Embedded Procedure Object

The following section describes:

• Embedded Procedures – ERP and other stored procedures, macros, etc. that allow functions to be executed without using a front-end interface.
• Properties and Methods – The properties of the function are the values sent and received from the backend system and the methods are commands used to manipulate the function such as ‘execute’ or ‘clear’ that operate on the object itself.

Embedded Procedures

An Embedded Procedure refers to embedding VBA code that performs a previously created task. The user may generate code for:

• Business Functions - typically used with ERP systems.
• Business Objects - an object variable used by Microsoft Axapta.
• Database Table - used to generate Insert SQL statements.
• Stored Procedures - found in ODBC compliant databases.
• Transaction Macros - to be queued or executed.
• Vocollect Recordsets - defined Vocollect resources.
• Web Service Objects - based on Web Service Connector.

Embedded Procedures are intended to be an automated approach to writing VBA code that specifies parameters and then executes the procedure. Although you can write the code yourself, RFgen has a code generator that makes this process much easier.

Methods and Properties

The methods and properties available in the Embedded Procedures group are:

emProc.Clear, emProc.ColumnCount, emProc.DataSource, emProc.DebugLog, emProc.DisableParam, emProc.Execute,

emProc.ExecuteMethod, emProc.LogMode, emProc.Name, emProc.Param, emProc.ParamCount, emProc.ParamEx, emProc.ParamName>

emProc.Queue, emProc.QueueName, emProc.QueueOffline, emProc.QueueSeqNo, emProc.RowCount, and emProc.SetKeyField.